Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | |
FederalID | The unique identifier for the FoodStamps program from which the tendered FoodStamps originated, as assigned by the United States Federal Government. | ID_FDL | Name | varchar(40) | |
SerialNumber | The serial number on the particular FoodStamps voucher that is being tendered. | UN_SRZ | Name | varchar(40) | |
ChangeAmount | The amount of change being returned to the Customer from this tender line item. This number may have to be reported upon to the government so it is recorded separately. | MO_CHG | MoneyShortRetail | decimal(7,2) | |